Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

Modifying records

You can use forms to update, copy, add, and delete records contained in a single table.

For example, if a query consists of the fields in the Customer table, you can use the Form view to modify the Customer table. However, if a query consists of fields from more than one table, you cannot modify the tables unless you use the Master-Detail feature to break the tables into individual frames. See the "Using Master and Detail sections to display records" section for more information.

The procedures in the following sections explain how to modify records contained within a single table.

Updating records

The following procedure describes how to update sections explain how to modify records contained within a single table.

To change the contents of one or more fields in a record:

Display the record you want to modify.
Choose Update.

Results displays the fields in the Update window. The first field is highlighted by default:



Select the contents of the field you want to modify, then type the new information in the field. The new information overwrites the old information.
When you are done modifying fields, choose OK to save your modifications and close the Update window.

As you update fields, you might find that your modifications are restricted by a variety of factors. For example, you cannot update a calculated field because it is a display only field. Or perhaps your company assigns unique customer numbers so you cannot update the Cust-Num field.

Copying records

The following section explains how to create a new record based on the contents of an old record. Be sure to follow the guidelines at your site for creating new records based on existing records.

To create a new record based on the contents of an old record:

Display the record you want to copy.
Choose Copy.

Results copies the record and displays the copy in the Update window. Results copies all the fields in the record whether or not the fields are displayed.

Since you are creating a new record, you will probably have to update several fields to reflect the new information.
When you are done modifying fields, choose OK to save your new record and close the update window.

Creating records

The following procedure describes how to create a new record.

To create a new record:

Choose Add.

Results creates a new record that contains all the fields in the table, then displays the record in the Add window. Note that only the fields you chose to display in the query are displayed in the window:



Some of the fields might already contain values, as in the Credit-Limit field. These initial values are determined by the business practices established by your company and enforced by the database.

Type values in the empty fields.
When you are done filling in fields, choose OK to save your record and close the Add window.

Deleting records

The following procedure describes how to delete a record.

To delete a record:

Display the record you want to delete.
Choose Delete. A dialog box prompts you to verify that you want to delete the record.
Choose Yes. Results deletes the entire record, including fields that are not displayed in the query.

You might find that you cannot delete a particular record. For example, you might not be able to delete a customer that has outstanding orders. Such restrictions are determined by your company’s business practices and are enforced by your database.